Tabela Job

Definicja tabeli Job

Name

Job

Code

Job

Comment

PL: Opis rodzaju umowy z pracodawca
EN: Contract between epmloyee and employer type description


Lista kolumn tabeli Job

Name

Code

JobID

JobID

JobTimeID

JobTimeID

JobTypeID

JobTypeID

UnitsCount

UnitsCount

PerNoOfUnits

PerNoOfUnits

Active

Active

HoursToWork

HoursToWork


Kolumna JobID tabeli Job

Definicja kolumny JobID tabeli Job

Name

JobID

Code

JobID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna JobTimeID tabeli Job

Definicja kolumny JobTimeID tabeli Job

Name

JobTimeID

Code

JobTimeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna JobTypeID tabeli Job

Definicja kolumny JobTypeID tabeli Job

Name

JobTypeID

Code

JobTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UnitsCount tabeli Job

Definicja kolumny UnitsCount tabeli Job

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(12,6)

Mandatory

No

Comment

 


Kolumna PerNoOfUnits tabeli Job

Definicja kolumny PerNoOfUnits tabeli Job

Name

PerNoOfUnits

Code

PerNoOfUnits

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli Job

Definicja kolumny Active tabeli Job

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna HoursToWork tabeli Job

Definicja kolumny HoursToWork tabeli Job

Name

HoursToWork

Code

HoursToWork

Data Type

NUMBER(12,6)

Mandatory

No

Comment

 


Lista kluczy tabeli Job

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Job

Definicja klucza Identifier_1 tabeli Job

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment